using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace LHS.Core.TableInfo
{
    public class InfoMedicine
    {
        public const string MEDISN = "medISN";
        public const string SKTISN = "sktISN";
        public const string MEDNAME = "medName";
        public const string MEDTYPE = "medType";

        //phan moi them
        public const string MIMMEDICINEORIGINALNAME = "mimMedicineOriginalName";
        public const string MEXUSAGE = "mexUsage";
        public const string MEXQUANTITYPERUNIT = "mexQuantityPerUnit";
        public const string MEXPRODUCTIONPERUNIT = "mexProductionPerUnit";
        public const string MEXDATEEXPORT = "mexDateExport";
        public const string MEXTAKEPERDAY = "mexTakePerDay";
        public const string MEXQUANTITYPERDAY = "mexQuantityPerDay";
        public const string MEXUSAGEPERDAY = "mexUsagePerDay";
        public const string MEXUSAGEUNIT = "mexUsageUnit";
        public const string MEXNOTE = "mexNote";

        //phan them 20090602
        public const string MEXMOREDETAILS = "mexMoreDetails";

        public const string TABLENAME = "Medicine";

        public static DataTable GetStructure()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add(MEDISN, typeof(int));
            dt.Columns.Add(SKTISN, typeof(int));
            dt.Columns.Add(MEDNAME, typeof(string));
            dt.Columns.Add(MEDTYPE, typeof(string));

            //phan moi them
            dt.Columns.Add(MIMMEDICINEORIGINALNAME, typeof(string));
            dt.Columns.Add(MEXUSAGE, typeof(string));
            dt.Columns.Add(MEXQUANTITYPERUNIT, typeof(int));
            dt.Columns.Add(MEXPRODUCTIONPERUNIT, typeof(int));
            dt.Columns.Add(MEXDATEEXPORT, typeof(DateTime));
            dt.Columns.Add(MEXTAKEPERDAY, typeof(int));
            dt.Columns.Add(MEXQUANTITYPERDAY, typeof(string));
            dt.Columns.Add(MEXUSAGEPERDAY, typeof(string));
            dt.Columns.Add(MEXUSAGEUNIT, typeof(string));
            dt.Columns.Add(MEXNOTE, typeof(string));

            //phan them 20090602
            dt.Columns.Add(MEXMOREDETAILS, typeof(string));

            dt.TableName = TABLENAME;
            return dt;
        }

    }
}
